*******************************************************************************
* East Baton Rouge
*******************************************************************************

use dataset_east_baton_rouge_meta, clear

keep Prop Year electionday early shareearly

keep if !mi(Year) & Year >= 2000

tostring election early, format("%20.0fc") replace force

tostring shareearly, format("%20.02fc") replace force

replace Prop = "Police tax" if regex(Prop, "tax")

#delimit;

listtex 
	*
		using "_output/table A23 a.tex"
		,
		replace
		type rstyle(tabular)
		head(
			\begin{tabular*}{\linewidth}{
				@{\hskip\tabcolsep\extracolsep\fill}l*{6}{l}}
			\toprule Year & Election & Election Day & Early
				& Share Early \\
			\midrule
		)
		foot("\bottomrule\end{tabular*}")
		;
		
#delimit cr

*******************************************************************************
* Fort Worth
*******************************************************************************

use dataset_fort_worth_meta, clear

keep Prop Year electionday early shareearly

keep if !mi(Year) & Year >= 2000 & !mi(early)

tostring election early, format("%20.0fc") replace force

tostring shareearly, format("%20.02fc") replace force

replace Prop = "Police tax" if regex(Prop, "tax")

#delimit;

listtex 
	*
		using "_output/table A23 b.tex"
		,
		replace
		type rstyle(tabular)
		head(
			\begin{tabular*}{\linewidth}{
				@{\hskip\tabcolsep\extracolsep\fill}l*{6}{l}}
			\toprule Year & Election & Election Day & Early
				& Share Early \\
			\midrule
		)
		foot("\bottomrule\end{tabular*}")
		;
		
#delimit cr

*******************************************************************************
* End
*******************************************************************************
